﻿# MySQL-Front 5.1  (Build 3.18)

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */;
/*!40101 SET SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */;
/*!40103 SET SQL_NOTES='ON' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS */;
/*!40014 SET FOREIGN_KEY_CHECKS=0 */;


# Host: localhost    Database: openshop
# ------------------------------------------------------
# Server version 5.1.35-community

#
# Source for table open_purchase_balance_order_detail
#

DROP TABLE IF EXISTS `open_purchase_balance_order_detail`;
CREATE TABLE `open_purchase_balance_order_detail` (
  `rec_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `order_type` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `associate_time` int(10) unsigned NOT NULL DEFAULT '0',
  `order_amount` decimal(10,2) unsigned NOT NULL DEFAULT '0.00',
  `payed_amount` decimal(10,2) unsigned NOT NULL DEFAULT '0.00',
  `pay_amount` decimal(10,2) unsigned NOT NULL DEFAULT '0.00',
  `surplus_amount` decimal(10,2) unsigned NOT NULL DEFAULT '0.00',
  `order_brief` tinytext NOT NULL,
  `add_time` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`rec_id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

#
# Dumping data for table open_purchase_balance_order_detail
#
LOCK TABLES `open_purchase_balance_order_detail` WRITE;
/*!40000 ALTER TABLE `open_purchase_balance_order_detail` DISABLE KEYS */;

INSERT INTO `open_purchase_balance_order_detail` VALUES (1,1,0,1257307200,7197.6,7197.6,7197.6,0,'',1257890077);
INSERT INTO `open_purchase_balance_order_detail` VALUES (2,1,0,1257307200,7197.6,7197.6,7197.6,0,'',1257890077);
INSERT INTO `open_purchase_balance_order_detail` VALUES (3,1,1,1257652800,8192,8192,8192,0,'',1257890077);
INSERT INTO `open_purchase_balance_order_detail` VALUES (4,2,0,1257307200,7197.6,7197.6,7197.6,0,'',1258044801);
INSERT INTO `open_purchase_balance_order_detail` VALUES (5,2,0,1257307200,7197.6,7197.6,7197.6,0,'',1258044801);
INSERT INTO `open_purchase_balance_order_detail` VALUES (6,2,1,1257652800,0,0,0,0,'',1258044801);
INSERT INTO `open_purchase_balance_order_detail` VALUES (7,2,1,1257393600,0,0,0,0,'',1258044801);
/*!40000 ALTER TABLE `open_purchase_balance_order_detail` ENABLE KEYS */;
UNLOCK TABLES;

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
